// 云函数入口文件
const cloud = require('wx-server-sdk')

cloud.init()
const db = cloud.database()
// 云函数入口函数
exports.main = async (event, context) => {

  var $ = db.command.aggregate
  return await db.collection('user_job')
  .aggregate()
  .lookup({
    from: "job",
    localField: "jobId",
    foreignField: "_id",
    as: "jobList"
  })
  .replaceRoot({
    newRoot: $.mergeObjects([ $.arrayElemAt(['$jobList', 0]), '$$ROOT' ])
  })
  .project({
    jobList: 0
  })
  .match({
    ...event.data
  })
  .end()
}